package com.dcloud.manage.service.entity;

import java.io.Serializable;
import java.io.UnsupportedEncodingException;
import java.util.Date;
import java.math.BigDecimal;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
import com.fasterxml.jackson.annotation.JsonFormat;
import org.springframework.format.annotation.DateTimeFormat;
import org.jeecgframework.poi.excel.annotation.Excel;
import org.jeecg.common.aspect.annotation.Dict;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;

/**
 * @Description: 任务sql表
 * @Author: jeecg-boot
 * @Date:   2022-09-07
 * @Version: V1.0
 */
@Data
@TableName("collect_task_sql")
@Accessors(chain = true)
@EqualsAndHashCode(callSuper = false)
@ApiModel(value="collect_task_sql对象", description="任务sql表")
public class CollectTaskSql implements Serializable {
    private static final long serialVersionUID = 1L;

	/**主键*/
	@Excel(name = "主键", width = 15)
    @ApiModelProperty(value = "主键")
    @TableId(type=IdType.AUTO)
    private Integer tid;
	/**任务主键*/
	@Excel(name = "任务主键", width = 15)
    @ApiModelProperty(value = "任务主键")
    private Integer taskTid;
	/**任务查询的sql*/
	@Excel(name = "任务查询的sql", width = 15)
    @ApiModelProperty(value = "任务查询的sql")
    private String taskSql;
	/**sql关联的数据源*/
	@Excel(name = "sql关联的数据源", width = 15)
    @ApiModelProperty(value = "sql关联的数据源")
    private Integer sourceId;
	/**同步方式全量还是增量 （0全量  1增量）*/
	@Excel(name = "同步方式全量还是增量 （0全量  1增量）", width = 15)
    @ApiModelProperty(value = "同步方式全量还是增量 （0全量  1增量）")
    private String syncType;
	/**增量字段*/
	@Excel(name = "增量字段", width = 15)
    @ApiModelProperty(value = "增量字段")
    private String incrementField;
	/**增量扩展时间*/
	@Excel(name = "增量扩展时间", width = 15)
    @ApiModelProperty(value = "增量扩展时间")
    private Integer extraDur;
	/**添加方式(insert,replace)*/
	@Excel(name = "添加方式(insert,replace)", width = 15)
    @ApiModelProperty(value = "添加方式(insert,replace)")
    private String appendType;
	/**创建时间*/
	@JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd")
    @DateTimeFormat(pattern="yyyy-MM-dd")
    @ApiModelProperty(value = "创建时间")
    private Date createTime;
}
